Share via

SSIS deploy command doesn't work on remote

arielman2304 676 Reputation points
May 12, 2021, 6:11 AM

I have the below deploy command which is working from my CMD (with no popup screen):

ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:"Integration Services\bin\Development\Integration Services.ispac" /DestinationServer:"TEST,1234" /DestinationPath:"/SSISDB/TEST/DEVOPS"

but when I'm running it thought Jenkins on windows server slave:

bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\"Integration Services\\bin\\Development\\Integration Services.ispac\" /DestinationServer:\"TEST,1234\" /DestinationPath:\"/SSISDB/TEST/DEVOPS\""

I get this exception:

   Unhandled Exception: System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.NetEnterpriseServers.ExceptionMessageBox.Show(IWin32Window owner)
   at Microsoft.SqlServer.IntegrationServices.Wizard.Common.WizardMessageBox.Show(Exception error)
   at Microsoft.SqlServer.IntegrationServices.Deployment.Program.Main(String[] args)

From what I read, this is probably due to popup screen which happens on the remote, but from the other hand, both commands are exactly the same

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,667 questions
{count} votes

Accepted answer
  1. arielman2304 676 Reputation points
    May 18, 2021, 4:41 PM

    Eventually, the syntax was good, but what was wrong is the DestinationServer. Instead using TEST,1234 I had to use the full organization address: TEST.XXX.YYY,1234
    What's works locally only with TEST,1234, is not working the same when talking on remote.
    What's annoying is that it didn't throw any error, only when I asked the Sys admin to login to the machine I was able to see the popup with the error.
    Detailed explanation for that, can be found here (also question which was raised by me):
    https://stackoverflow.com/a/67047195/14976099

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. MotoX80 35,626 Reputation points
    May 15, 2021, 1:02 AM

    I don't have any way to test Jenkins, but based on experience (and depending on how Jenkins parses quotes) you may need to additional double quote characters in order to get a double quote character included in the command.

    From the 1st to 2nd double quotes the command would be:

    ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\
    

    Try these commands and see if either of them works. I'm thinking that the second one might work.

    bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\""Integration Services\\bin\\Development\\Integration Services.ispac\"" /DestinationServer:\""TEST,1234\"" /DestinationPath:\""/SSISDB/TEST/DEVOPS\"""
    
    bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\"""Integration Services\\bin\\Development\\Integration Services.ispac\""" /DestinationServer:\"""TEST,1234\""" /DestinationPath:\"""/SSISDB/TEST/DEVOPS\"""" 
    

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.